Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	29503
Missing cells	104176
Missing cells (%)	16.1%
Duplicate rows	24
Duplicate rows (%)	0.1%
Total size in memory	5.0 MiB
Average record size in memory	176.0 B

Variable types

NUM	13
CAT	6
BOOL	2
URL	1

Reproduction

Analysis started	2021-11-19 20:36:35.382126
Analysis finished	2021-11-19 20:38:03.177671
Duration	1 minute and 27.8 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

Dataset has 24 (0.1%) duplicate rows	Duplicates
`song_id` has a high cardinality: 29386 distinct values	High cardinality
`performer` has a high cardinality: 10059 distinct values	High cardinality
`song` has a high cardinality: 24359 distinct values	High cardinality
`spotify_genre` has a high cardinality: 3375 distinct values	High cardinality
`spotify_track_id` has a high cardinality: 24177 distinct values	High cardinality
`spotify_track_album` has a high cardinality: 13125 distinct values	High cardinality
`spotify_genre` has 1600 (5.4%) missing values	Missing
`spotify_track_id` has 5106 (17.3%) missing values	Missing
`spotify_track_preview_url` has 15012 (50.9%) missing values	Missing
`spotify_track_duration_ms` has 5106 (17.3%) missing values	Missing
`spotify_track_explicit` has 5106 (17.3%) missing values	Missing
`spotify_track_album` has 5112 (17.3%) missing values	Missing
`danceability` has 5169 (17.5%) missing values	Missing
`energy` has 5169 (17.5%) missing values	Missing
`key` has 5169 (17.5%) missing values	Missing
`loudness` has 5169 (17.5%) missing values	Missing
`mode` has 5169 (17.5%) missing values	Missing
`speechiness` has 5169 (17.5%) missing values	Missing
`acousticness` has 5169 (17.5%) missing values	Missing
`instrumentalness` has 5169 (17.5%) missing values	Missing
`liveness` has 5169 (17.5%) missing values	Missing
`valence` has 5169 (17.5%) missing values	Missing
`tempo` has 5169 (17.5%) missing values	Missing
`time_signature` has 5169 (17.5%) missing values	Missing
`spotify_track_popularity` has 5106 (17.3%) missing values	Missing
`song_id` is uniformly distributed	Uniform
`song` is uniformly distributed	Uniform
`spotify_track_id` is uniformly distributed	Uniform
`key` has 3035 (10.3%) zeros	Zeros
`instrumentalness` has 10079 (34.2%) zeros	Zeros

song_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	29386
Unique (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	230.5 KiB

It's The Most Wonderful Time Of The YearAndy Williams	2
Even Though I'm LeavingLuke Combs	2
CoolJonas Brothers	2
24/7Meek Mill Featuring Ella Mai	2
Middle ChildJ. Cole	2
Other values (29381)	29493

Common Values
Length

Value	Count	Frequency (%)
It's The Most Wonderful Time Of The YearAndy Williams	2	< 0.1%
Even Though I'm LeavingLuke Combs	2	< 0.1%
CoolJonas Brothers	2	< 0.1%
24/7Meek Mill Featuring Ella Mai	2	< 0.1%
Middle ChildJ. Cole	2	< 0.1%
Sunflower (Spider-Man: Into The Spider-Verse)Post Malone & Swae Lee	2	< 0.1%
Only HumanJonas Brothers	2	< 0.1%
Good As YouKane Brown	2	< 0.1%
Life Goes OnBTS	2	< 0.1%
Wish WishDJ Khaled Featuring Cardi B & 21 Savage	2	< 0.1%
Other values (29376)	29483	99.9%

Length

Max length	123
Median length	29
Mean length	31.618954
Min length	5

performer
Categorical

HIGH CARDINALITY

Distinct count	10059
Unique (%)	34.1%
Missing	0
Missing (%)	0.0%
Memory size	230.5 KiB

Glee Cast	183
Taylor Swift	119
Drake	99
The Beatles	65
Aretha Franklin	64
Other values (10054)	28973

Common Values
Length

Value	Count	Frequency (%)
Glee Cast	183	0.6%
Taylor Swift	119	0.4%
Drake	99	0.3%
The Beatles	65	0.2%
Aretha Franklin	64	0.2%
Elton John	58	0.2%
The Rolling Stones	57	0.2%
The Beach Boys	54	0.2%
Stevie Wonder	54	0.2%
Elvis Presley With The Jordanaires	53	0.2%
Other values (10049)	28697	97.3%

Length

Max length	113
Median length	12
Mean length	15.06450192
Min length	1

song
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	24359
Unique (%)	82.6%
Missing	0
Missing (%)	0.0%
Memory size	230.5 KiB

Hold On	17
Stay	14
Forever	14
Angel	14
You	14
Other values (24354)	29430

Common Values
Length

Value	Count	Frequency (%)
Hold On	17	0.1%
Stay	14	< 0.1%
Forever	14	< 0.1%
Angel	14	< 0.1%
You	14	< 0.1%
Happy	13	< 0.1%
Without You	12	< 0.1%
Runaway	12	< 0.1%
Smile	12	< 0.1%
Hallelujah	11	< 0.1%
Other values (24349)	29370	99.5%

Length

Max length	75
Median length	15
Mean length	16.55553673
Min length	1

spotify_genre
Categorical

HIGH CARDINALITY
MISSING

Distinct count	3375
Unique (%)	12.1%
Missing	1600
Missing (%)	5.4%
Memory size	230.5 KiB

[]	2557
['contemporary country', 'country', 'country road']	326
['contemporary country', 'country', 'country road', 'modern country rock']	294
['dance pop', 'pop', 'post-teen pop']	285
['glee club', 'hollywood', 'post-teen pop']	206
Other values (3370)	24235

Common Values
Length

Value	Count	Frequency (%)
[]	2557	8.7%
['contemporary country', 'country', 'country road']	326	1.1%
['contemporary country', 'country', 'country road', 'modern country rock']	294	1.0%
['dance pop', 'pop', 'post-teen pop']	285	1.0%
['glee club', 'hollywood', 'post-teen pop']	206	0.7%
['canadian hip hop', 'canadian pop', 'hip hop', 'pop rap', 'rap', 'toronto rap']	147	0.5%
['deep adult standards']	129	0.4%
['adult standards', 'easy listening', 'lounge']	129	0.4%
['bubblegum pop']	127	0.4%
['pop', 'post-teen pop']	116	0.4%
Other values (3365)	23587	79.9%
(Missing)	1600	5.4%

Length

Max length	319
Median length	58
Mean length	63.11903874
Min length	2

spotify_track_id
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	24177
Unique (%)	99.1%
Missing	5106
Missing (%)	17.3%
Memory size	230.5 KiB

2QpGZOhTCHHiKmpSO9FW4h	4
1GeNui6m825V8jP4uKiIaH	4
249gnXrbfmV8NG6jTEMSwD	4
2pXpURmn6zC5ZYDMms6fwa	3
0iA1unTbTbDOWUSlbwJ1pS	3
Other values (24172)	24379

Common Values
Length

Value	Count	Frequency (%)
2QpGZOhTCHHiKmpSO9FW4h	4	< 0.1%
1GeNui6m825V8jP4uKiIaH	4	< 0.1%
249gnXrbfmV8NG6jTEMSwD	4	< 0.1%
2pXpURmn6zC5ZYDMms6fwa	3	< 0.1%
0iA1unTbTbDOWUSlbwJ1pS	3	< 0.1%
25leEEaz1gIpp7o21Fqyjo	3	< 0.1%
3HVWdVOQ0ZA45FuZGSfvns	3	< 0.1%
3mRM4NM8iO7UBqrSigCQFH	3	< 0.1%
3Jw2A9SC8zhntx4ON9VabX	2	< 0.1%
3RzcoFkZ0AOp2nH71jP504	2	< 0.1%
Other values (24167)	24366	82.6%
(Missing)	5106	17.3%

Length

Max length	22
Median length	22
Mean length	18.71172423
Min length	3

spotify_track_preview_url
URL

MISSING

Distinct count	14371
Unique (%)	99.2%
Missing	15012
Missing (%)	50.9%
Memory size	230.5 KiB

https://p.scdn.co/mp3-preview/909f15e56869916ec4a0b8bc846c6282fab32a44?cid=b8d3901151d34489a160e3cf0ab1fa94	4
https://p.scdn.co/mp3-preview/9dc29ff47cbdda2d3c5a66b3fabf9c7420f62950?cid=b8d3901151d34489a160e3cf0ab1fa94	4
https://p.scdn.co/mp3-preview/d50d2c9b3b4f9522b5a1f6aba3eef17a3b1ad8bf?cid=b8d3901151d34489a160e3cf0ab1fa94	3
https://p.scdn.co/mp3-preview/40d2bf0a16b4a4c7e5747a57943f9c0bbf5bc5ab?cid=b8d3901151d34489a160e3cf0ab1fa94	3
https://p.scdn.co/mp3-preview/d4bc22abe2badf30a4be265e3ed00710fe71ca0a?cid=b8d3901151d34489a160e3cf0ab1fa94	3
Other values (14366)	14474
(Missing)	15012

Value	Count	Frequency (%)
https://p.scdn.co/mp3-preview/909f15e56869916ec4a0b8bc846c6282fab32a44?cid=b8d3901151d34489a160e3cf0ab1fa94	4	< 0.1%
https://p.scdn.co/mp3-preview/9dc29ff47cbdda2d3c5a66b3fabf9c7420f62950?cid=b8d3901151d34489a160e3cf0ab1fa94	4	< 0.1%
https://p.scdn.co/mp3-preview/d50d2c9b3b4f9522b5a1f6aba3eef17a3b1ad8bf?cid=b8d3901151d34489a160e3cf0ab1fa94	3	< 0.1%
https://p.scdn.co/mp3-preview/40d2bf0a16b4a4c7e5747a57943f9c0bbf5bc5ab?cid=b8d3901151d34489a160e3cf0ab1fa94	3	< 0.1%
https://p.scdn.co/mp3-preview/d4bc22abe2badf30a4be265e3ed00710fe71ca0a?cid=b8d3901151d34489a160e3cf0ab1fa94	3	< 0.1%
https://p.scdn.co/mp3-preview/4826dc0c324e562c2810137b967e34d998a0dec9?cid=b8d3901151d34489a160e3cf0ab1fa94	2	< 0.1%
https://p.scdn.co/mp3-preview/6d9117232204a352333ba7f29a9f6534c8457a9e?cid=b8d3901151d34489a160e3cf0ab1fa94	2	< 0.1%
https://p.scdn.co/mp3-preview/18a4b26ead90425c3b671deb85eb2f74521a7614?cid=b8d3901151d34489a160e3cf0ab1fa94	2	< 0.1%
https://p.scdn.co/mp3-preview/49cc18d925f58e9c8c9bc3e6d75038d87fd4f8da?cid=b8d3901151d34489a160e3cf0ab1fa94	2	< 0.1%
https://p.scdn.co/mp3-preview/e028e330ed9f9d517d3e6a9180fd834fdefafebb?cid=b8d3901151d34489a160e3cf0ab1fa94	2	< 0.1%
Other values (14361)	14464	49.0%
(Missing)	15012	50.9%

Value	Count	Frequency (%)
https	14491	49.1%
(Missing)	15012	50.9%

Value	Count	Frequency (%)
p.scdn.co	14491	49.1%
(Missing)	15012	50.9%

Value	Count	Frequency (%)
/mp3-preview/909f15e56869916ec4a0b8bc846c6282fab32a44	4	< 0.1%
/mp3-preview/9dc29ff47cbdda2d3c5a66b3fabf9c7420f62950	4	< 0.1%
/mp3-preview/d50d2c9b3b4f9522b5a1f6aba3eef17a3b1ad8bf	3	< 0.1%
/mp3-preview/40d2bf0a16b4a4c7e5747a57943f9c0bbf5bc5ab	3	< 0.1%
/mp3-preview/d4bc22abe2badf30a4be265e3ed00710fe71ca0a	3	< 0.1%
/mp3-preview/cef4883cfd1e0e5312be7ccce98176cff46d7879	2	< 0.1%
/mp3-preview/4826dc0c324e562c2810137b967e34d998a0dec9	2	< 0.1%
/mp3-preview/6d9117232204a352333ba7f29a9f6534c8457a9e	2	< 0.1%
/mp3-preview/18a4b26ead90425c3b671deb85eb2f74521a7614	2	< 0.1%
/mp3-preview/49cc18d925f58e9c8c9bc3e6d75038d87fd4f8da	2	< 0.1%
Other values (14361)	14464	49.0%
(Missing)	15012	50.9%

Value	Count	Frequency (%)
cid=b8d3901151d34489a160e3cf0ab1fa94	14491	49.1%
(Missing)	15012	50.9%

Value	Count	Frequency (%)
	14491	49.1%
(Missing)	15012	50.9%

spotify_track_duration_ms
Real number (ℝ_≥0)

MISSING

Distinct count	13984
Unique (%)	57.3%
Missing	5106
Missing (%)	17.3%
Infinite	0
Infinite (%)	0.0%

Mean	220684.25818748208
Minimum	29688.0
Maximum	3079157.0
Zeros	0
Zeros (%)	0.0%
Memory size	230.5 KiB

Quantile statistics

Minimum	29688
5-th percentile	135660.8
Q1	175053
median	214850
Q3	253253
95-th percentile	327752
Maximum	3079157
Range	3049469
Interquartile range (IQR)	78200

Descriptive statistics

Standard deviation	67746.70686
Coefficient of variation (CV)	0.3069847728
Kurtosis	146.2472513
Mean	220684.2582
Median Absolute Deviation (MAD)	39150
Skewness	4.97287579
Sum	5384033847
Variance	4589616290

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
205733	10	< 0.1%
160000	10	< 0.1%
280000	9	< 0.1%
161533	9	< 0.1%
231400	9	< 0.1%
251333	9	< 0.1%
229466	9	< 0.1%
196000	9	< 0.1%
227266	9	< 0.1%
201000	8	< 0.1%
Other values (13974)	24306	82.4%
(Missing)	5106	17.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
29688	1	< 0.1%
37013	1	< 0.1%
46253	1	< 0.1%
48000	1	< 0.1%
49292	1	< 0.1%

Value	Count	Frequency (%)
3079157	1	< 0.1%
1561133	1	< 0.1%
1367093	1	< 0.1%
1124153	1	< 0.1%
1008533	1	< 0.1%

spotify_track_explicit
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	5106
Missing (%)	17.3%
Memory size	230.5 KiB

False	21449
True	2948
(Missing)	5106

Frequency Table

Value	Count	Frequency (%)
False	21449	72.7%
True	2948	10.0%
(Missing)	5106	17.3%

spotify_track_album
Categorical

HIGH CARDINALITY
MISSING

Distinct count	13125
Unique (%)	53.8%
Missing	5112
Missing (%)	17.3%
Memory size	230.5 KiB

Greatest Hits	247
Glee: The Musi	110
Gold	65
The Definitive Collection	59
Super Hits	55
Other values (13120)	23855

Common Values
Length

Value	Count	Frequency (%)
Greatest Hits	247	0.8%
Glee: The Musi	110	0.4%
Gold	65	0.2%
The Definitive Collection	59	0.2%
Super Hits	55	0.2%
Capitol Collectors Series	49	0.2%
Anthology	37	0.1%
20 Greatest Hits	36	0.1%
Love Songs	32	0.1%
Stax-Volt: The Complete Singles 1959-1968	25	0.1%
Other values (13115)	23676	80.2%
(Missing)	5112	17.3%

Length

Max length	2688
Median length	15
Mean length	63.13998576
Min length	1

danceability
Real number (ℝ_≥0)

MISSING

Distinct count	837
Unique (%)	3.4%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	0.5999449741102985
Minimum	0.0
Maximum	0.988
Zeros	1
Zeros (%)	< 0.1%
Memory size	230.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0.329
Q1	0.499
median	0.608
Q3	0.708
95-th percentile	0.845
Maximum	0.988
Range	0.988
Interquartile range (IQR)	0.209

Descriptive statistics

Standard deviation	0.1531328317
Coefficient of variation (CV)	0.2552447946
Kurtosis	-0.2350591204
Mean	0.5999449741
Median Absolute Deviation (MAD)	0.104
Skewness	-0.2365619072
Sum	14599.061
Variance	0.02344966413

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.637	86	0.3%
0.628	82	0.3%
0.674	82	0.3%
0.652	81	0.3%
0.66	80	0.3%
0.602	79	0.3%
0.61	79	0.3%
0.551	77	0.3%
0.589	76	0.3%
0.669	74	0.3%
Other values (827)	23538	79.8%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.103	1	< 0.1%
0.105	1	< 0.1%
0.107	1	< 0.1%
0.11	1	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.986	1	< 0.1%
0.981	1	< 0.1%
0.98	2	< 0.1%
0.978	2	< 0.1%

energy
Real number (ℝ_≥0)

MISSING

Distinct count	985
Unique (%)	4.0%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	0.6180960664502342
Minimum	0.000581
Maximum	0.997
Zeros	0
Zeros (%)	0.0%
Memory size	230.5 KiB

Quantile statistics

Minimum	0.000581
5-th percentile	0.26865
Q1	0.476
median	0.634
Q3	0.778
95-th percentile	0.91335
Maximum	0.997
Range	0.996419
Interquartile range (IQR)	0.302

Descriptive statistics

Standard deviation	0.1990776548
Coefficient of variation (CV)	0.3220820607
Kurtosis	-0.5964968364
Mean	0.6180960665
Median Absolute Deviation (MAD)	0.15
Skewness	-0.3292516288
Sum	15040.74968
Variance	0.03963191264

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.73	62	0.2%
0.671	58	0.2%
0.727	58	0.2%
0.72	58	0.2%
0.804	57	0.2%
0.743	57	0.2%
0.641	56	0.2%
0.61	56	0.2%
0.703	54	0.2%
0.623	54	0.2%
Other values (975)	23764	80.5%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.000581	1	< 0.1%
0.0181	1	< 0.1%
0.0201	1	< 0.1%
0.0204	1	< 0.1%
0.021	1	< 0.1%

Value	Count	Frequency (%)
0.997	1	< 0.1%
0.996	2	< 0.1%
0.995	4	< 0.1%
0.994	5	< 0.1%
0.993	6	< 0.1%

key
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct count	12
Unique (%)	< 0.1%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	5.231651187638695
Minimum	0.0
Maximum	11.0
Zeros	3035
Zeros (%)	10.3%
Memory size	230.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.560210518
Coefficient of variation (CV)	0.6805137403
Kurtosis	-1.290505415
Mean	5.231651188
Median Absolute Deviation (MAD)	3
Skewness	0.001457898841
Sum	127307
Variance	12.67509893

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	3035	10.3%
7	2852	9.7%
2	2502	8.5%
9	2448	8.3%
5	2183	7.4%
1	2181	7.4%
4	1885	6.4%
10	1773	6.0%
11	1702	5.8%
8	1519	5.1%
Other values (2)	2254	7.6%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3035	10.3%
1	2181	7.4%
2	2502	8.5%
3	819	2.8%
4	1885	6.4%

Value	Count	Frequency (%)
11	1702	5.8%
10	1773	6.0%
9	2448	8.3%
8	1519	5.1%
7	2852	9.7%

loudness
Real number (ℝ)

MISSING

Distinct count	11165
Unique (%)	45.9%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	-8.664606969672064
Minimum	-28.03
Maximum	2.291
Zeros	0
Zeros (%)	0.0%
Memory size	230.5 KiB

Quantile statistics

Minimum	-28.03
5-th percentile	-15.06935
Q1	-11.034
median	-8.205
Q3	-5.85625
95-th percentile	-3.703
Maximum	2.291
Range	30.321
Interquartile range (IQR)	5.17775

Descriptive statistics

Standard deviation	3.601118745
Coefficient of variation (CV)	-0.4156124747
Kurtosis	0.3474572723
Mean	-8.66460697
Median Absolute Deviation (MAD)	2.538
Skewness	-0.6487828184
Sum	-210844.546
Variance	12.96805621

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-5.318	10	< 0.1%
-9.088	10	< 0.1%
-7.076	10	< 0.1%
-5.18	10	< 0.1%
-5.076	9	< 0.1%
-5.79	9	< 0.1%
-8.749	9	< 0.1%
-5.987	9	< 0.1%
-6.836	9	< 0.1%
-8.302	8	< 0.1%
Other values (11155)	24241	82.2%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-28.03	1	< 0.1%
-27.861	1	< 0.1%
-27.119	1	< 0.1%
-27.01	1	< 0.1%
-26.826	1	< 0.1%

Value	Count	Frequency (%)
2.291	1	< 0.1%
0.175	1	< 0.1%
-0.463	1	< 0.1%
-0.507	1	< 0.1%
-0.517	1	< 0.1%

mode
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	5169
Missing (%)	17.5%
Memory size	230.5 KiB

1	17695
0	6639
(Missing)	5169

Frequency Table

Value	Count	Frequency (%)
1	17695	60.0%
0	6639	22.5%
(Missing)	5169	17.5%

speechiness
Real number (ℝ_≥0)

MISSING

Distinct count	1230
Unique (%)	5.1%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	0.07355373962357196
Minimum	0.0
Maximum	0.951
Zeros	1
Zeros (%)	< 0.1%
Memory size	230.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0.027
Q1	0.0321
median	0.0413
Q3	0.0683
95-th percentile	0.268
Maximum	0.951
Range	0.951
Interquartile range (IQR)	0.0362

Descriptive statistics

Standard deviation	0.08315294367
Coefficient of variation (CV)	1.130505996
Kurtosis	12.49501975
Mean	0.07355373962
Median Absolute Deviation (MAD)	0.0116
Skewness	3.161387843
Sum	1789.8567
Variance	0.006914412041

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.0295	118	0.4%
0.0287	116	0.4%
0.0303	115	0.4%
0.0299	114	0.4%
0.0294	113	0.4%
0.0317	112	0.4%
0.029	111	0.4%
0.0319	110	0.4%
0.0306	110	0.4%
0.0293	109	0.4%
Other values (1220)	23206	78.7%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.022	1	< 0.1%
0.0221	1	< 0.1%
0.0224	5	< 0.1%
0.0225	3	< 0.1%

Value	Count	Frequency (%)
0.951	1	< 0.1%
0.924	1	< 0.1%
0.913	1	< 0.1%
0.894	1	< 0.1%
0.888	1	< 0.1%

acousticness
Real number (ℝ_≥0)

MISSING

Distinct count	3057
Unique (%)	12.6%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	0.2946349385551081
Minimum	2.51e-06
Maximum	0.991
Zeros	0
Zeros (%)	0.0%
Memory size	230.5 KiB

Quantile statistics

Minimum	2.51e-06
5-th percentile	0.00265
Q1	0.0467
median	0.195
Q3	0.508
95-th percentile	0.839
Maximum	0.991
Range	0.99099749
Interquartile range (IQR)	0.4613

Descriptive statistics

Standard deviation	0.2822998323
Coefficient of variation (CV)	0.9581342719
Kurtosis	-0.7203809464
Mean	0.2946349386
Median Absolute Deviation (MAD)	0.1748
Skewness	0.7615942476
Sum	7169.646595
Variance	0.07969319533

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.117	50	0.2%
0.111	48	0.2%
0.107	47	0.2%
0.101	47	0.2%
0.113	47	0.2%
0.105	45	0.2%
0.114	45	0.2%
0.13	45	0.2%
0.104	44	0.1%
0.108	44	0.1%
Other values (3047)	23872	80.9%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.51e-06	1	< 0.1%
3.28e-06	1	< 0.1%
3.29e-06	1	< 0.1%
5.67e-06	1	< 0.1%
7.81e-06	1	< 0.1%

Value	Count	Frequency (%)
0.991	1	< 0.1%
0.99	2	< 0.1%
0.989	1	< 0.1%
0.988	4	< 0.1%
0.987	5	< 0.1%

instrumentalness
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct count	4424
Unique (%)	18.2%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	0.03253903274102079
Minimum	0.0
Maximum	0.982
Zeros	10079
Zeros (%)	34.2%
Memory size	230.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4.53e-06
Q3	0.00046
95-th percentile	0.16935
Maximum	0.982
Range	0.982
Interquartile range (IQR)	0.00046

Descriptive statistics

Standard deviation	0.13627614
Coefficient of variation (CV)	4.188082083
Kurtosis	25.5874268
Mean	0.03253903274
Median Absolute Deviation (MAD)	4.53e-06
Skewness	5.04044
Sum	791.8048227
Variance	0.01857118633

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	10079	34.2%
1.16e-06	25	0.1%
1.03e-05	25	0.1%
1.17e-06	19	0.1%
1.2e-06	19	0.1%
1.1e-06	18	0.1%
1.19e-05	18	0.1%
1.05e-05	18	0.1%
0.000104	18	0.1%
1.23e-05	18	0.1%
Other values (4414)	14077	47.7%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10079	34.2%
1e-06	4	< 0.1%
1.01e-06	17	0.1%
1.02e-06	14	< 0.1%
1.03e-06	15	0.1%

Value	Count	Frequency (%)
0.982	2	< 0.1%
0.981	1	< 0.1%
0.978	1	< 0.1%
0.966	2	< 0.1%
0.965	2	< 0.1%

liveness
Real number (ℝ_≥0)

MISSING

Distinct count	1611
Unique (%)	6.6%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	0.19209814950275333
Minimum	0.00967
Maximum	0.999
Zeros	0
Zeros (%)	0.0%
Memory size	230.5 KiB

Quantile statistics

Minimum	0.00967
5-th percentile	0.0521
Q1	0.0909
median	0.131
Q3	0.24875
95-th percentile	0.533
Maximum	0.999
Range	0.98933
Interquartile range (IQR)	0.15785

Descriptive statistics

Standard deviation	0.1590732298
Coefficient of variation (CV)	0.8280830928
Kurtosis	5.183385052
Mean	0.1920981495
Median Absolute Deviation (MAD)	0.0558
Skewness	2.104336497
Sum	4674.51637
Variance	0.02530429243

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.106	202	0.7%
0.111	200	0.7%
0.107	197	0.7%
0.108	189	0.6%
0.11	185	0.6%
0.105	183	0.6%
0.114	180	0.6%
0.109	179	0.6%
0.112	176	0.6%
0.104	175	0.6%
Other values (1601)	22468	76.2%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.00967	1	< 0.1%
0.013	1	< 0.1%
0.0136	2	< 0.1%
0.0145	1	< 0.1%
0.0146	1	< 0.1%

Value	Count	Frequency (%)
0.999	1	< 0.1%
0.997	1	< 0.1%
0.991	1	< 0.1%
0.99	2	< 0.1%
0.989	2	< 0.1%

valence
Real number (ℝ_≥0)

MISSING

Distinct count	1103
Unique (%)	4.5%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	0.6017455782033369
Minimum	0.0
Maximum	0.991
Zeros	1
Zeros (%)	< 0.1%
Memory size	230.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0.189
Q1	0.415
median	0.622
Q3	0.802
95-th percentile	0.955
Maximum	0.991
Range	0.991
Interquartile range (IQR)	0.387

Descriptive statistics

Standard deviation	0.2386449117
Coefficient of variation (CV)	0.3965877281
Kurtosis	-0.9403941207
Mean	0.6017455782
Median Absolute Deviation (MAD)	0.192
Skewness	-0.2710511243
Sum	14642.8769
Variance	0.0569513939

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.961	136	0.5%
0.963	118	0.4%
0.962	118	0.4%
0.964	100	0.3%
0.965	91	0.3%
0.96	83	0.3%
0.966	71	0.2%
0.969	58	0.2%
0.967	57	0.2%
0.926	56	0.2%
Other values (1093)	23446	79.5%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.0349	1	< 0.1%
0.0352	1	< 0.1%
0.0359	1	< 0.1%
0.0361	1	< 0.1%

Value	Count	Frequency (%)
0.991	1	< 0.1%
0.99	1	< 0.1%
0.989	1	< 0.1%
0.988	1	< 0.1%
0.987	1	< 0.1%

tempo
Real number (ℝ_≥0)

MISSING

Distinct count	20485
Unique (%)	84.2%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	120.27606599819183
Minimum	0.0
Maximum	241.009
Zeros	1
Zeros (%)	< 0.1%
Memory size	230.5 KiB

Quantile statistics

Minimum	0
5-th percentile	79.15565
Q1	99.06075
median	118.9105
Q3	136.48375
95-th percentile	173.828
Maximum	241.009
Range	241.009
Interquartile range (IQR)	37.423

Descriptive statistics

Standard deviation	28.04693691
Coefficient of variation (CV)	0.2331880136
Kurtosis	0.01715271641
Mean	120.276066
Median Absolute Deviation (MAD)	18.9255
Skewness	0.5139289391
Sum	2926797.79
Variance	786.6306703

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
119.987	8	< 0.1%
119.991	7	< 0.1%
99.991	6	< 0.1%
140.022	6	< 0.1%
119.999	6	< 0.1%
119.986	6	< 0.1%
116	6	< 0.1%
125.008	6	< 0.1%
120.08	6	< 0.1%
128.002	6	< 0.1%
Other values (20475)	24271	82.3%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
35.716	1	< 0.1%
36.71	1	< 0.1%
37.114	1	< 0.1%
47.94	1	< 0.1%

Value	Count	Frequency (%)
241.009	1	< 0.1%
233.429	1	< 0.1%
216.2	1	< 0.1%
213.737	1	< 0.1%
211.261	1	< 0.1%

time_signature
Real number (ℝ_≥0)

MISSING

Distinct count	5
Unique (%)	< 0.1%
Missing	5169
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%

Mean	3.931577217062546
Minimum	0.0
Maximum	5.0
Zeros	2
Zeros (%)	< 0.1%
Memory size	230.5 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	4
median	4
Q3	4
95-th percentile	4
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3208578217
Coefficient of variation (CV)	0.08161045912
Kurtosis	31.00434877
Mean	3.931577217
Median Absolute Deviation (MAD)	0
Skewness	-4.348588928
Sum	95671
Variance	0.1029497418

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	22489	76.2%
3	1564	5.3%
5	186	0.6%
1	93	0.3%
0	2	< 0.1%
(Missing)	5169	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	93	0.3%
3	1564	5.3%
4	22489	76.2%
5	186	0.6%

Value	Count	Frequency (%)
5	186	0.6%
4	22489	76.2%
3	1564	5.3%
1	93	0.3%
0	2	< 0.1%

spotify_track_popularity
Real number (ℝ_≥0)

MISSING

Distinct count	101
Unique (%)	0.4%
Missing	5106
Missing (%)	17.3%
Infinite	0
Infinite (%)	0.0%

Mean	41.224412837643975
Minimum	0.0
Maximum	100.0
Zeros	280
Zeros (%)	0.9%
Memory size	230.5 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	23
median	43
Q3	59
95-th percentile	76
Maximum	100
Range	100
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	22.47740512
Coefficient of variation (CV)	0.5452450034
Kurtosis	-0.981106233
Mean	41.22441284
Median Absolute Deviation (MAD)	18
Skewness	-0.0593203259
Sum	1005752
Variance	505.2337408

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
44	398	1.3%
53	397	1.3%
47	394	1.3%
57	392	1.3%
52	383	1.3%
48	381	1.3%
54	374	1.3%
45	370	1.3%
55	370	1.3%
58	363	1.2%
Other values (91)	20575	69.7%
(Missing)	5106	17.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	280	0.9%
1	234	0.8%
2	221	0.7%
3	241	0.8%
4	250	0.8%

Value	Count	Frequency (%)
100	2	< 0.1%
99	1	< 0.1%
98	2	< 0.1%
97	5	< 0.1%
96	6	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	song_id	performer	song	spotify_genre	spotify_track_id	spotify_track_preview_url	spotify_track_duration_ms	spotify_track_explicit	spotify_track_album	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	time_signature	spotify_track_popularity
0	-twistin'-White Silver SandsBill Black's Combo	Bill Black's Combo	-twistin'-White Silver Sands	[]	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	¿Dònde Està Santa Claus? (Where Is Santa Claus?)Augie Rios	Augie Rios	¿Dònde Està Santa Claus? (Where Is Santa Claus?)	['novelty']	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	......And Roses And RosesAndy Williams	Andy Williams	......And Roses And Roses	['adult standards', 'brill building pop', 'easy listening', 'mellow gold']	3tvqPPpXyIgKrm4PR9HCf0	https://p.scdn.co/mp3-preview/cef4883cfd1e0e5312be7ccce98176cff46d7879?cid=b8d3901151d34489a160e3cf0ab1fa94	166106.0	False	The Essential Andy Williams	0.154	0.185	5.0	-14.063	1.0	0.0315	0.91100	0.000267	0.112	0.150	83.969	4.0	38.0
3	...And Then There Were DrumsSandy Nelson	Sandy Nelson	...And Then There Were Drums	['rock-and-roll', 'space age pop', 'surf music']	1fHHq3qHU8wpRKHzhojZ4a	NaN	172066.0	False	Compelling Percussion	0.588	0.672	11.0	-17.278	0.0	0.0361	0.00256	0.745000	0.145	0.801	121.962	4.0	11.0
4	...Baby One More TimeBritney Spears	Britney Spears	...Baby One More Time	['dance pop', 'pop', 'post-teen pop']	3MjUtNVVq3C8Fn0MP3zhXa	https://p.scdn.co/mp3-preview/da2134a161f1cb34d17c2d6d7e77cc93d1c1e6f7?cid=b8d3901151d34489a160e3cf0ab1fa94	211066.0	False	...Baby One More Time (Digital Deluxe Version)	0.759	0.699	0.0	-5.745	0.0	0.0307	0.20200	0.000131	0.443	0.907	92.960	4.0	77.0
5	...Ready For It?Taylor Swift	Taylor Swift	...Ready For It?	['pop', 'post-teen pop']	2yLa0QULdQr0qAIvVwN6B5	NaN	208186.0	False	{'album_type': 'album', 'artists': [{'external_urls': {'spotify': 'https://open.spotify.com/artist/06HL4z0CvFAxyc27GXpf02'}, 'href': 'https://api.spotify.com/v1/artists/06HL4z0CvFAxyc27GXpf02', 'id': '06HL4z0CvFAxyc27GXpf02', 'name': 'Taylor Swift', 'type': 'artist', 'uri': 'spotify:artist:06HL4z0CvFAxyc27GXpf02'}], 'available_markets': ['AD', 'AE', 'AG', 'AL', 'AM', 'AO', 'AR', 'AT', 'AU', 'AZ', 'BA', 'BB', 'BD', 'BE', 'BF', 'BG', 'BH', 'BI', 'BJ', 'BN', 'BO', 'BR', 'BS', 'BT', 'BW', 'BY', 'BZ', 'CA', 'CH', 'CI', 'CL', 'CM', 'CO', 'CR', 'CV', 'CW', 'CY', 'CZ', 'DE', 'DJ', 'DK', 'DM', 'DO', 'DZ', 'EC', 'EE', 'EG', 'ES', 'FI', 'FJ', 'FM', 'FR', 'GA', 'GB', 'GD', 'GE', 'GH', 'GM', 'GN', 'GQ', 'GR', 'GT', 'GW', 'GY', 'HK', 'HN', 'HR', 'HT', 'HU', 'ID', 'IE', 'IL', 'IN', 'IS', 'IT', 'JM', 'JO', 'JP', 'KE', 'KG', 'KH', 'KI', 'KM', 'KN', 'KR', 'KW', 'KZ', 'LA', 'LB', 'LC', 'LI', 'LK', 'LR', 'LS', 'LT', 'LU', 'LV', 'MA', 'MC', 'MD', 'ME', 'MG', 'MH', 'MK', 'ML', 'MN', 'MO', 'MR', 'MT', 'MU', 'MV', 'MW', 'MX', 'MY', 'MZ', 'NA', 'NE', 'NG', 'NI', 'NL', 'NO', 'NP', 'NR', 'NZ', 'OM', 'PA', 'PE', 'PG', 'PH', 'PK', 'PL', 'PS', 'PT', 'PW', 'PY', 'QA', 'RO', 'RS', 'RU', 'RW', 'SA', 'SB', 'SC', 'SE', 'SG', 'SI', 'SK', 'SL', 'SM', 'SN', 'SR', 'ST', 'SV', 'SZ', 'TD', 'TG', 'TH', 'TL', 'TN', 'TO', 'TR', 'TT', 'TV', 'TW', 'TZ', 'UA', 'UG', 'US', 'UY', 'UZ', 'VC', 'VN', 'VU', 'WS', 'XK', 'ZA', 'ZM', 'ZW'], 'external_urls': {'spotify': 'https://open.spotify.com/album/6DEjYFkNZh67HP7R9PSZvv'}, 'href': 'https://api.spotify.com/v1/albums/6DEjYFkNZh67HP7R9PSZvv', 'id': '6DEjYFkNZh67HP7R9PSZvv', 'images': [{'height': 640, 'url': 'https://i.scdn.co/image/ab67616d0000b273da5d5aeeabacacc1263c0f4b', 'width': 640}, {'height': 300, 'url': 'https://i.scdn.co/image/ab67616d00001e02da5d5aeeabacacc1263c0f4b', 'width': 300}, {'height': 64, 'url': 'https://i.scdn.co/image/ab67616d00004851da5d5aeeabacacc1263c0f4b', 'width': 64}], 'name': 'reputation', 'release_date': '2017-11-10', 'release_date_precision': 'day', 'total_tracks': 15, 'type': 'album', 'uri': 'spotify:album:6DEjYFkNZh67HP7R9PSZvv'}	0.613	0.764	2.0	-6.509	1.0	0.1360	0.05270	0.000000	0.197	0.417	160.015	4.0	73.0
6	'03 Bonnie & ClydeJay-Z Featuring Beyonce Knowles	Jay-Z Featuring Beyonce Knowles	'03 Bonnie & Clyde	['east coast hip hop', 'hip hop', 'pop rap', 'rap', 'southern hip hop']	5ljCWsDlSyJ41kwqym2ORw	NaN	205560.0	True	The Blueprint 2 The Gift & The Curse	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	61.0
7	'65 Love AffairPaul Davis	Paul Davis	'65 Love Affair	['album rock', 'bubblegum pop', 'country rock', 'folk rock', 'mellow gold', 'new wave pop', 'soft rock', 'yacht rock']	5nBp8F6tekSrnFg8G2Pvug	https://p.scdn.co/mp3-preview/a701445830ecacfb521200da9507753586200453?cid=b8d3901151d34489a160e3cf0ab1fa94	219813.0	False	Radio Hits Of the '80s	0.647	0.686	2.0	-4.247	0.0	0.0274	0.43200	0.000006	0.133	0.952	155.697	4.0	40.0
8	'98 Thug ParadiseTragedy, Capone, Infinite	Tragedy, Capone, Infinite	'98 Thug Paradise	['english indie rock']	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	'Round We GoBig Sister	Big Sister	'Round We Go	[]	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Last rows

	song_id	performer	song	spotify_genre	spotify_track_id	spotify_track_preview_url	spotify_track_duration_ms	spotify_track_explicit	spotify_track_album	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	time_signature	spotify_track_popularity
29493	Zing Went The Strings Of My HeartThe Trammps	The Trammps	Zing Went The Strings Of My Heart	['disco', 'motown', 'philly soul', 'post-disco']	6QkdsyKK6Pq2wWuSgnpgQi	https://p.scdn.co/mp3-preview/b89d82622921dbd2ea6c791e192ce97e99565a19?cid=b8d3901151d34489a160e3cf0ab1fa94	202693.0	False	The Trammps	0.667	0.851	4.0	-5.257	1.0	0.0629	0.03380	0.000001	0.3180	0.830	120.132	4.0	32.0
29494	Zing! Went The Strings Of My HeartThe Furys	The Furys	Zing! Went The Strings Of My Heart	[]	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29495	Zip CodeThe Five Americans	The Five Americans	Zip Code	['bubblegum pop', 'classic garage rock', 'freakbeat']	7hTW791CEdFSlw2wouCVYP	https://p.scdn.co/mp3-preview/dbdb31b788ce42e4c040f368ea748ed03feeff0f?cid=b8d3901151d34489a160e3cf0ab1fa94	175040.0	False	The Five Americans (Rerecorded Versions)	0.393	0.594	9.0	-5.986	1.0	0.0267	0.03940	0.000000	0.0479	0.927	139.535	4.0	5.0
29496	Zip-A-Dee Doo-DahBob B. Soxx And The Blue Jeans	Bob B. Soxx And The Blue Jeans	Zip-A-Dee Doo-Dah	['brill building pop']	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29497	ZombieBad Wolves	Bad Wolves	Zombie	['alternative metal', 'metal', 'post-grunge']	1vNoA9F5ASnlBISFekDmg3	https://p.scdn.co/mp3-preview/4978147ac417f06049825616fdd66cabdb566ae7?cid=b8d3901151d34489a160e3cf0ab1fa94	254805.0	False	Zombie	0.448	0.826	2.0	-3.244	0.0	0.0319	0.00756	0.000000	0.1170	0.190	77.093	4.0	74.0
29498	Zoo YorkLil Tjay Featuring Fivio Foreign & Pop Smoke	Lil Tjay Featuring Fivio Foreign & Pop Smoke	Zoo York	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29499	ZoomFuture	Future	Zoom	['atl hip hop', 'hip hop', 'pop rap', 'rap', 'southern hip hop', 'trap']	2IG6Te7JyvrtqhFeOF7le4	https://p.scdn.co/mp3-preview/cb8fde6edc08e70a9650ca877a8c53b2ecf980fd?cid=b8d3901151d34489a160e3cf0ab1fa94	278429.0	True	FUTURE	0.852	0.438	9.0	-7.673	1.0	0.4260	0.01450	0.000000	0.2630	0.627	150.945	4.0	51.0
29500	ZoomLil' Boosie Featuring Yung Joc	Lil' Boosie Featuring Yung Joc	Zoom	['baton rouge rap', 'deep southern trap']	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29501	Zorba The GreekHerb Alpert & The Tijuana Brass	Herb Alpert & The Tijuana Brass	Zorba The Greek	['adult standards', 'easy listening', 'lounge']	3WLEVNohakzZmMpN5W7mHK	https://p.scdn.co/mp3-preview/1841a4034ba42fc07df76af815ba62f4b206466b?cid=b8d3901151d34489a160e3cf0ab1fa94	264853.0	False	!!!Going Places!!!	0.531	0.642	5.0	-12.702	1.0	0.3230	0.15400	0.279000	0.0584	0.192	82.107	4.0	35.0
29502	Zunga ZengK7	K7	Zunga Zeng	['freestyle']	0XevPPcCBPovknaBw3lFvh	https://p.scdn.co/mp3-preview/8d5174aeb7d6b7409b7e36dfc42082d9d8a32e6a?cid=b8d3901151d34489a160e3cf0ab1fa94	273000.0	False	Swing Batta Swing!	0.846	0.657	1.0	-9.642	1.0	0.1400	0.04780	0.000363	0.0392	0.619	103.743	4.0	28.0

Most frequent

	song_id	performer	song	spotify_genre	spotify_track_id	spotify_track_preview_url	spotify_track_duration_ms	spotify_track_explicit	spotify_track_album	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	time_signature	spotify_track_popularity	count
0	Bad Bad BadYoung Thug Featuring Lil Baby	Young Thug Featuring Lil Baby	Bad Bad Bad	['atl hip hop', 'atl trap', 'gangster rap', 'melodic rap', 'pop rap', 'rap', 'trap']	1GeNui6m825V8jP4uKiIaH	https://p.scdn.co/mp3-preview/909f15e56869916ec4a0b8bc846c6282fab32a44?cid=b8d3901151d34489a160e3cf0ab1fa94	149040.0	True	So Much Fun	0.974	0.596	6.0	-8.888	1.0	0.1840	0.09760	0.000000	0.1510	0.892	111.959	4.0	82.0	2
1	Beer Never Broke My HeartLuke Combs	Luke Combs	Beer Never Broke My Heart	['contemporary country']	3RzcoFkZ0AOp2nH71jP504	https://p.scdn.co/mp3-preview/6a1fbf9017964d3ad2d1f11cf9288bc2eadd9c04?cid=b8d3901151d34489a160e3cf0ab1fa94	186733.0	False	What You See Is What You Get	0.540	0.863	1.0	-4.483	1.0	0.0481	0.01380	0.000000	0.0874	0.640	77.000	4.0	79.0	2
2	EarfquakeTyler, The Creator	Tyler, The Creator	Earfquake	['hip hop', 'rap']	5hVghJ4KaYES3BFUATCYn0	https://p.scdn.co/mp3-preview/d6528c193bac76f7a04bdf1ea9453ec016a94f88?cid=b8d3901151d34489a160e3cf0ab1fa94	190066.0	True	IGOR	0.554	0.498	9.0	-8.866	1.0	0.0685	0.23000	0.000006	0.7950	0.413	79.635	4.0	85.0	2
3	JuiceLizzo	Lizzo	Juice	['escape room', 'minnesota hip hop', 'pop', 'pop rap', 'trap queen']	0k664IuFwVP557Gnx7RhIl	https://p.scdn.co/mp3-preview/7ca1598cec36c49118562b02491b9a030e233d88?cid=b8d3901151d34489a160e3cf0ab1fa94	195144.0	True	Cuz I Love You	0.767	0.889	7.0	-2.988	1.0	0.0963	0.00611	0.000000	0.4020	0.843	119.930	4.0	82.0	2
4	Life Goes OnBTS	BTS	Life Goes On	['k-pop', 'k-pop boy group']	249gnXrbfmV8NG6jTEMSwD	https://p.scdn.co/mp3-preview/9dc29ff47cbdda2d3c5a66b3fabf9c7420f62950?cid=b8d3901151d34489a160e3cf0ab1fa94	207481.0	False	{'album_type': 'album', 'artists': [{'external_urls': {'spotify': 'https://open.spotify.com/artist/3Nrfpe0tUJi4K4DXYWgMUX'}, 'href': 'https://api.spotify.com/v1/artists/3Nrfpe0tUJi4K4DXYWgMUX', 'id': '3Nrfpe0tUJi4K4DXYWgMUX', 'name': 'BTS', 'type': 'artist', 'uri': 'spotify:artist:3Nrfpe0tUJi4K4DXYWgMUX'}], 'available_markets': ['AD', 'AE', 'AG', 'AL', 'AM', 'AO', 'AR', 'AT', 'AU', 'AZ', 'BA', 'BB', 'BD', 'BE', 'BF', 'BG', 'BH', 'BI', 'BJ', 'BN', 'BO', 'BR', 'BS', 'BT', 'BW', 'BY', 'BZ', 'CA', 'CH', 'CI', 'CL', 'CM', 'CO', 'CR', 'CV', 'CY', 'CZ', 'DE', 'DJ', 'DK', 'DM', 'DO', 'DZ', 'EC', 'EE', 'EG', 'ES', 'FI', 'FJ', 'FM', 'FR', 'GA', 'GB', 'GD', 'GE', 'GH', 'GM', 'GN', 'GQ', 'GR', 'GT', 'GW', 'GY', 'HK', 'HN', 'HR', 'HT', 'HU', 'ID', 'IE', 'IL', 'IN', 'IS', 'IT', 'JM', 'JO', 'JP', 'KE', 'KG', 'KH', 'KI', 'KM', 'KN', 'KW', 'KZ', 'LA', 'LB', 'LC', 'LI', 'LK', 'LR', 'LS', 'LT', 'LU', 'LV', 'MA', 'MC', 'MD', 'ME', 'MG', 'MH', 'MK', 'ML', 'MN', 'MO', 'MR', 'MT', 'MU', 'MV', 'MW', 'MX', 'MY', 'MZ', 'NA', 'NE', 'NG', 'NI', 'NL', 'NO', 'NP', 'NR', 'NZ', 'OM', 'PA', 'PE', 'PG', 'PH', 'PK', 'PL', 'PS', 'PT', 'PW', 'PY', 'QA', 'RO', 'RS', 'RU', 'RW', 'SA', 'SB', 'SC', 'SE', 'SG', 'SI', 'SK', 'SL', 'SM', 'SN', 'SR', 'ST', 'SV', 'SZ', 'TD', 'TG', 'TH', 'TL', 'TN', 'TO', 'TR', 'TT', 'TV', 'TW', 'TZ', 'UA', 'UG', 'US', 'UY', 'UZ', 'VC', 'VN', 'VU', 'WS', 'XK', 'ZA', 'ZM', 'ZW'], 'external_urls': {'spotify': 'https://open.spotify.com/album/2qehskW9lYGWfYb0xPZkrS'}, 'href': 'https://api.spotify.com/v1/albums/2qehskW9lYGWfYb0xPZkrS', 'id': '2qehskW9lYGWfYb0xPZkrS', 'images': [{'height': 640, 'url': 'https://i.scdn.co/image/ab67616d0000b2733deb4b0115410a85afe31c29', 'width': 640}, {'height': 300, 'url': 'https://i.scdn.co/image/ab67616d00001e023deb4b0115410a85afe31c29', 'width': 300}, {'height': 64, 'url': 'https://i.scdn.co/image/ab67616d000048513deb4b0115410a85afe31c29', 'width': 64}], 'name': 'BE', 'release_date': '2020-11-20', 'release_date_precision': 'day', 'total_tracks': 8, 'type': 'album', 'uri': 'spotify:album:2qehskW9lYGWfYb0xPZkrS'}	0.566	0.716	1.0	-5.733	1.0	0.0424	0.00691	0.000000	0.3700	0.450	81.068	4.0	87.0	2
5	Lil BabyYoung Thug	Young Thug	Lil Baby	['atl hip hop', 'atl trap', 'gangster rap', 'melodic rap', 'pop rap', 'rap', 'trap']	1GeNui6m825V8jP4uKiIaH	https://p.scdn.co/mp3-preview/909f15e56869916ec4a0b8bc846c6282fab32a44?cid=b8d3901151d34489a160e3cf0ab1fa94	149040.0	True	So Much Fun	0.974	0.596	6.0	-8.888	1.0	0.1840	0.09760	0.000000	0.1510	0.892	111.959	4.0	82.0	2
6	ONBTS	BTS	ON	['k-pop', 'k-pop boy group']	249gnXrbfmV8NG6jTEMSwD	https://p.scdn.co/mp3-preview/9dc29ff47cbdda2d3c5a66b3fabf9c7420f62950?cid=b8d3901151d34489a160e3cf0ab1fa94	207481.0	False	{'album_type': 'album', 'artists': [{'external_urls': {'spotify': 'https://open.spotify.com/artist/3Nrfpe0tUJi4K4DXYWgMUX'}, 'href': 'https://api.spotify.com/v1/artists/3Nrfpe0tUJi4K4DXYWgMUX', 'id': '3Nrfpe0tUJi4K4DXYWgMUX', 'name': 'BTS', 'type': 'artist', 'uri': 'spotify:artist:3Nrfpe0tUJi4K4DXYWgMUX'}], 'available_markets': ['AD', 'AE', 'AG', 'AL', 'AM', 'AO', 'AR', 'AT', 'AU', 'AZ', 'BA', 'BB', 'BD', 'BE', 'BF', 'BG', 'BH', 'BI', 'BJ', 'BN', 'BO', 'BR', 'BS', 'BT', 'BW', 'BY', 'BZ', 'CA', 'CH', 'CI', 'CL', 'CM', 'CO', 'CR', 'CV', 'CY', 'CZ', 'DE', 'DJ', 'DK', 'DM', 'DO', 'DZ', 'EC', 'EE', 'EG', 'ES', 'FI', 'FJ', 'FM', 'FR', 'GA', 'GB', 'GD', 'GE', 'GH', 'GM', 'GN', 'GQ', 'GR', 'GT', 'GW', 'GY', 'HK', 'HN', 'HR', 'HT', 'HU', 'ID', 'IE', 'IL', 'IN', 'IS', 'IT', 'JM', 'JO', 'JP', 'KE', 'KG', 'KH', 'KI', 'KM', 'KN', 'KW', 'KZ', 'LA', 'LB', 'LC', 'LI', 'LK', 'LR', 'LS', 'LT', 'LU', 'LV', 'MA', 'MC', 'MD', 'ME', 'MG', 'MH', 'MK', 'ML', 'MN', 'MO', 'MR', 'MT', 'MU', 'MV', 'MW', 'MX', 'MY', 'MZ', 'NA', 'NE', 'NG', 'NI', 'NL', 'NO', 'NP', 'NR', 'NZ', 'OM', 'PA', 'PE', 'PG', 'PH', 'PK', 'PL', 'PS', 'PT', 'PW', 'PY', 'QA', 'RO', 'RS', 'RU', 'RW', 'SA', 'SB', 'SC', 'SE', 'SG', 'SI', 'SK', 'SL', 'SM', 'SN', 'SR', 'ST', 'SV', 'SZ', 'TD', 'TG', 'TH', 'TL', 'TN', 'TO', 'TR', 'TT', 'TV', 'TW', 'TZ', 'UA', 'UG', 'US', 'UY', 'UZ', 'VC', 'VN', 'VU', 'WS', 'XK', 'ZA', 'ZM', 'ZW'], 'external_urls': {'spotify': 'https://open.spotify.com/album/2qehskW9lYGWfYb0xPZkrS'}, 'href': 'https://api.spotify.com/v1/albums/2qehskW9lYGWfYb0xPZkrS', 'id': '2qehskW9lYGWfYb0xPZkrS', 'images': [{'height': 640, 'url': 'https://i.scdn.co/image/ab67616d0000b2733deb4b0115410a85afe31c29', 'width': 640}, {'height': 300, 'url': 'https://i.scdn.co/image/ab67616d00001e023deb4b0115410a85afe31c29', 'width': 300}, {'height': 64, 'url': 'https://i.scdn.co/image/ab67616d000048513deb4b0115410a85afe31c29', 'width': 64}], 'name': 'BE', 'release_date': '2020-11-20', 'release_date_precision': 'day', 'total_tracks': 8, 'type': 'album', 'uri': 'spotify:album:2qehskW9lYGWfYb0xPZkrS'}	0.566	0.716	1.0	-5.733	1.0	0.0424	0.00691	0.000000	0.3700	0.450	81.068	4.0	87.0	2
7	Old Town RoadLil Nas X Featuring Billy Ray Cyrus	Lil Nas X Featuring Billy Ray Cyrus	Old Town Road	['country rap', 'lgbtq+ hip hop', 'pop rap']	2YpeDb67231RjR0MgVLzsG	https://p.scdn.co/mp3-preview/d94ec2ebe62fd52cf038760f57c251c145346bb2?cid=b8d3901151d34489a160e3cf0ab1fa94	157066.0	False	7 EP	0.878	0.619	6.0	-5.560	1.0	0.1020	0.05330	0.000000	0.1130	0.639	136.041	4.0	91.0	2

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent